SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Spacious 2-level, 4 bedroom, 3 full bath home in great in-town Hanover location, 1-mile walk to Hanover Inn corner and College Green. With generously proportioned interior spaces, hardwood and ceramic tile floors throughout (including eco-friendly bamboo on the lower level), the home offers beds, baths and living spaces on both ground floor and lower, walk-out levels. The lot is sited on a semi-private 1.3 acre parcel, with abundant vegetation, lawn spaces, and foliage, adjacent to the Dartmouth College 9-hole practice golf course, and bordered by Girl Brook and the Girl Brook East hiking trail. The house has a total of 4,365 sf of finished living space, plus 2 basement areas for utilities, storage and shop, an attached 2-car garage, front porch, rear deck and patio; it is deceptively larger, with more depth than one might assume from a curbside view, and, should be seen to be fully appreciated. Building inspection report available for the house.
Description:A breath of fresh air on the in-town Hanover real estate market, this very pretty house is located close to the end of a cul-de-sac and also close to an access for the Appalachian Trail. With a large 1.89+/-ac lot, the open floor plan makes the kitchen/dining room/living room/sunroom a truly welcoming space and wonderful for entertaining. Newer primary suite is spacious and has privacy and quiet. 3-4 additional bedrooms and 2.5 additional bathrooms complete the picture. First floor laundry. Two potential offices. Sunset views. Two car attached garage. A great one!
Description:Beautifully renovated classic four bedroom Hanover home, walking distance to Main Street, Dartmouth College and Hanover High School. Three bedrooms and two baths on the second floor, modern primary suite addition on the first floor, presently being rented as a studio apartment. Gracious living room with fireplace, dining room and large, bright eat-in kitchen with butler's pantry. Two offices on the first floor. Gorgeous hardwood floors throughout. Large deck, 2 car garage. Beautiful trees. Super neighborhood.
Description:The Lake House on Mascoma - Situated on one of the best parcels Mascoma Lake has to offer, this stunning 4 bedroom, 2 bathroom home offers the ultimate lake living experience. It has been fully renovated, with updated heating and air conditioning systems, electrical, plumbing, roof, windows, stunning stone hearth with a propane fireplace and more, yet it retains the comfortable, easy-going feel of a classic lake house. Beautiful landscaping frames over 110’ of lake frontage, a private sandy beach, boat launch, large lawn, and views for miles - this property is a dream for lake-living enthusiasts. 20 minutes from Dartmouth College, Dartmouth Health, Colby-Sawyer College, Kimball Union Academy and Cardigan Mountain School. Less than 2 hours to Boston.
Description:A special opportunity to acquire a generously proportioned, privately situated, carefully maintained home in Hanover, NH. In 1989, a business owner and Dartmouth alum collaborated with a noted architect to construct a thoughtful residence on over 3 acres — just short of the cul-de-sac in a quiet neighborhood, roughly halfway between the Lyme Green and Dartmouth Green. Offered for the first time. This 5-bedroom, 5-bath lends itself to a multiplicity of shared living arrangements. The stucco-clad section of the house centers on a courtyard defined by stone walls. The potential large quarters above the oversized three-car garage might be ideal as an independently accessible space for in-laws or teenagers. There is a further space on the lowest walkout level of the house that has historically been used as an attractive office space. Fireplaces, rarely used in the 35 years, anchor the two separate living rooms. The atriums on each flanking end of the house help to define the unusual aspects of this home. The more dramatic atrium, accessed via the front door, floods, the house with light. The entire interior and exterior were recently painted, and newly installed hardwood floors add a fresh glow to the house. Generous storage space and closets abound. This uncluttered house is entirely appropriate for rapid occupancy and yet lends itself to possible re-imagination by new owners. Enjoy privacy and main highway access to Hanover and Lyme, and I-91 from this singular home.